--SELECT * FROM tiger_salesman
--DELETE FROM tiger_salesman
INSERT INTO tiger_salesman
SELECT
'00000000-0000-0000-0000-0000000000' + convert(varchar(2),id) AS  [Id],Account AS [Username],AdminPwd AS [Password],NULL AS [PasswordSalt],Username AS [Fullname],0 AS [IsManager],1 AS [Actice],0 AS [Deleted],NULL AS [ExpiryDate],0 As [IsAdmin],isnull(createddate,getdate()) AS [DateCreated],LastLoginDate AS [LastSignedIn]FROM srv_lnk.nchr2008.dbo.sitemanager
where account in('yy','youyou','tr1','zwy','zzj','wangfeng','huyb','admin')

--SELECT * FROM srv_lnk.nchr2008.dbo.sitemanager
--where account in('yy','youyou','tr1','zwy','zzj','wangfeng','huyb')